title 'Cleaned Countries, salaries and dates'; data work.clean; set hercules.nonsales; Country=upcase(Country); if Employee_ID=120106 then Salary=26960; else if Employee_ID=120115 then Salary=26500; else if Employee_ID=120191 then Salary=24015; else if Employee_ID=120107 then Hire_Date='21JAN1995'd; else if Employee_ID=120111 then Hire_Date='01NOV1978'd; else if Employee_ID=121011 then Hire_Date='01JAN1998'd; if employee_id=. then employee_id=120116; run; proc print data=work.clean; var Employee_ID Salary Job_Title Country Hire_Date; run; title;